SELECT flight.*, flightlang.flight_name, flightlang.flight_dpro, flightlang.flight_apro, airlang.airline_name, airlang.airline_desc, planelang.plane_name, (
SELECT airport_name
FROM tbl_airport_lang
WHERE airport_id = flight_dairp AND lang_id = flightlang.lang_id) AS dairp_name, (
SELECT airport_name
FROM tbl_airport_lang
WHERE airport_id = flight_aairp AND lang_id = flightlang.lang_id) AS aairp_name, ftime.*
FROM tbl_flight AS flight
INNER JOIN tbl_flight_lang AS flightlang ON flightlang.flight_id = flight.flight_id
INNER JOIN tbl_airline AS airl ON airl.airline_id = flight.airline_id
INNER JOIN tbl_airline_lang AS airlang ON airlang.airline_id = airl.airline_id
INNER JOIN tbl_plane AS plane ON plane.plane_id = flight.plane_id
INNER JOIN tbl_plane_lang AS planelang ON planelang.plane_id = plane.plane_id
INNER JOIN tbl_flight_time AS ftime ON ftime.flight_id = flight.flight_id
LEFT JOIN tbl_airport_lang AS dairport_name ON flight.flight_dairp = dairport_name.airport_id
LEFT JOIN tbl_airport AS dairport_code ON flight.flight_dairp = dairport_code.airport_id
LEFT JOIN tbl_province_lang AS dprovince ON dairport_code.province_id = dprovince.province_id
WHERE 1 = 1 
AND LOWER(flight.flight_type) = 'inbound' AND flight.status = 1 AND flightlang.lang_id = 3 AND airlang.lang_id = 3 AND planelang.lang_id = 3
ORDER BY flight.flight_sort